//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Copyright 2006 CORE Solutions Limited
// All rights reserved.
// PROPRIETARY AND CONFIDENTIAL INFORMATION.
// Use is subject to license terms.
//
// FUNCTION ID      :   USER
// AUTHOR           :   Jimmy chen 
// DATE CREATE      :   2006/09/01
// DESCRIPTION      :   a SCHEMA file for the function, USER
//                  :   
//                  :   
//                  :   
//
// MODIFICATION HISTORY:
// DATE         AUTHOR          VERSION NO.         COMMENT
// -----------  --------------  ------------------  -------------------
// 2006/09/01   Jimmy chen      1.0                 source is generated.
//
//
//
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package com.erp.app.admin.userSetup.schema;

import com.erp.framework.model.schema.MetaData;
import com.erp.framework.model.schema.TableSchema;

/**
* <p>A <strong>Schema</strong> stores the table meta information.
* The main purpose for this class is to validate the lengths of UniCode Characters,
* and notify the database to store UniCode characters from web browsers.
*
* @author          Jimmy chen 
* @version 1.0     2006/09/01
* @since           FrameWork 1.0
*
*/
public class UserSignatureSchema extends TableSchema {

	public static final String TABLE_NAME = "T_USER_SIGNATURE";

	public UserSignatureSchema(){

		MetaData md = null;

		md = new MetaData();
		md.setColumnName("COMPANY_CODE");
		md.setVoPropertyName("companyCode");
		md.setColumnTitle("COMPANY_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_SIGNATURE_COMPANY_CODE");
		md.setWebLabelName("DEF SIGNATURE COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COMPANY_CODE");
		md.setVoPropertyName("srchCompanyCodeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COMPANY_CODE");
		md.setVoPropertyName("srchCompanyCodeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_COMPANY_CODE");
		md.setVoPropertyName("lblGridCompanyCode");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_COMPANY_CODE");
		md.setWebLabelName("DEF GRID COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("USER_CODE");
		md.setVoPropertyName("userCode");
		md.setColumnTitle("USER_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_SIGNATURE_USER_CODE");
		md.setWebLabelName("DEF SIGNATURE USER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_USER_CODE");
		md.setVoPropertyName("srchUserCodeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_USER_CODE");
		md.setWebLabelName("DEF SRCH USER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_USER_CODE");
		md.setVoPropertyName("srchUserCodeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_USER_CODE");
		md.setWebLabelName("DEF SRCH USER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_USER_CODE");
		md.setVoPropertyName("lblGridUserCode");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_USER_CODE");
		md.setWebLabelName("DEF GRID USER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LINE_NO");
		md.setVoPropertyName("signatureLineNo");
		md.setColumnTitle("LINE_NO");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(5);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_SIGNATURE_LINE_NO");
		md.setWebLabelName("DEF SIGNATURE LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_LINE_NO");
		md.setVoPropertyName("srchSignatureLineNoFr");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_LINE_NO");
		md.setWebLabelName("DEF SRCH LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_LINE_NO");
		md.setVoPropertyName("srchSignatureLineNoTo");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_LINE_NO");
		md.setWebLabelName("DEF SRCH LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_LINE_NO");
		md.setVoPropertyName("lblGridSignatureLineNo");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_LINE_NO");
		md.setWebLabelName("DEF GRID LINE NO");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("SIGNATURE_TYPE");
		md.setVoPropertyName("signatureSignatureType");
		md.setColumnTitle("SIGNATURE_TYPE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_SIGNATURE_SIGNATURE_TYPE");
		md.setWebLabelName("DEF SIGNATURE SIGNATURE TYPE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_SIGNATURE_TYPE");
		md.setVoPropertyName("srchSignatureSignatureTypeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_SIGNATURE_TYPE");
		md.setWebLabelName("DEF SRCH SIGNATURE TYPE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_SIGNATURE_TYPE");
		md.setVoPropertyName("srchSignatureSignatureTypeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_SIGNATURE_TYPE");
		md.setWebLabelName("DEF SRCH SIGNATURE TYPE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_SIGNATURE_TYPE");
		md.setVoPropertyName("lblGridSignatureSignatureType");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_SIGNATURE_TYPE");
		md.setWebLabelName("DEF GRID SIGNATURE TYPE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CONTENT_TYPE");
		md.setVoPropertyName("signatureContentType");
		md.setColumnTitle("CONTENT_TYPE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SIGNATURE_CONTENT_TYPE");
		md.setWebLabelName("DEF SIGNATURE CONTENT TYPE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_CONTENT_TYPE");
		md.setVoPropertyName("srchSignatureContentTypeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_CONTENT_TYPE");
		md.setWebLabelName("DEF SRCH CONTENT TYPE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_CONTENT_TYPE");
		md.setVoPropertyName("srchSignatureContentTypeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_CONTENT_TYPE");
		md.setWebLabelName("DEF SRCH CONTENT TYPE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_CONTENT_TYPE");
		md.setVoPropertyName("lblGridSignatureContentType");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_CONTENT_TYPE");
		md.setWebLabelName("DEF GRID CONTENT TYPE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("DESCRIPTION");
		md.setVoPropertyName("signatureDescription");
		md.setColumnTitle("DESCRIPTION");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(2000);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(2000);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SIGNATURE_DESCRIPTION");
		md.setWebLabelName("DEF SIGNATURE DESCRIPTION");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_DESCRIPTION");
		md.setVoPropertyName("srchSignatureDescriptionFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_DESCRIPTION");
		md.setWebLabelName("DEF SRCH DESCRIPTION");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_DESCRIPTION");
		md.setVoPropertyName("srchSignatureDescriptionTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_DESCRIPTION");
		md.setWebLabelName("DEF SRCH DESCRIPTION");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_DESCRIPTION");
		md.setVoPropertyName("lblGridSignatureDescription");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_DESCRIPTION");
		md.setWebLabelName("DEF GRID DESCRIPTION");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("SIGNATURE");
		md.setVoPropertyName("signatureSignature");
		md.setColumnTitle("SIGNATURE");
		md.setColumnTypeName("LONG RAW");
		md.setColumnType(-4);
		md.setColumnSize(0);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(2147483647);
		md.setColumnScale(0);
		md.setDisplaySize(0);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SIGNATURE_SIGNATURE");
		md.setWebLabelName("DEF SIGNATURE SIGNATURE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_SIGNATURE");
		md.setVoPropertyName("srchSignatureSignatureFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_SIGNATURE");
		md.setWebLabelName("DEF SRCH SIGNATURE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_SIGNATURE");
		md.setVoPropertyName("srchSignatureSignatureTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_SIGNATURE");
		md.setWebLabelName("DEF SRCH SIGNATURE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_SIGNATURE");
		md.setVoPropertyName("lblGridSignatureSignature");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_SIGNATURE");
		md.setWebLabelName("DEF GRID SIGNATURE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("DC_IND");
		md.setVoPropertyName("signatureDcInd");
		md.setColumnTitle("DC_IND");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SIGNATURE_DC_IND");
		md.setWebLabelName("DEF SIGNATURE DC IND");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("DC_DATE");
		md.setVoPropertyName("signatureDcDate");
		md.setColumnTitle("DC_DATE");
		md.setColumnTypeName("DATE");
		md.setColumnType(91);
		md.setColumnSize(15);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomSqlDate");
		md.setColumnPrecision(0);
		md.setColumnScale(0);
		md.setDisplaySize(15);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SIGNATURE_DC_DATE");
		md.setWebLabelName("DEF SIGNATURE DC DATE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CREATE_USER");
		md.setVoPropertyName("createUser");
		md.setColumnTitle("CREATE_USER");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SIGNATURE_CREATE_USER");
		md.setWebLabelName("DEF SIGNATURE CREATE USER");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CREATE_DATE");
		md.setVoPropertyName("createDate");
		md.setColumnTitle("CREATE_DATE");
		md.setColumnTypeName("DATE");
		md.setColumnType(91);
		md.setColumnSize(15);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.sql.Timestamp");
		md.setColumnPrecision(0);
		md.setColumnScale(0);
		md.setDisplaySize(15);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SIGNATURE_CREATE_DATE");
		md.setWebLabelName("DEF SIGNATURE CREATE DATE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("UPDATE_USER");
		md.setVoPropertyName("updateUser");
		md.setColumnTitle("UPDATE_USER");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SIGNATURE_UPDATE_USER");
		md.setWebLabelName("DEF SIGNATURE UPDATE USER");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("UPDATE_DATE");
		md.setVoPropertyName("updateDate");
		md.setColumnTitle("UPDATE_DATE");
		md.setColumnTypeName("DATE");
		md.setColumnType(91);
		md.setColumnSize(15);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.sql.Timestamp");
		md.setColumnPrecision(0);
		md.setColumnScale(0);
		md.setDisplaySize(15);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SIGNATURE_UPDATE_DATE");
		md.setWebLabelName("DEF SIGNATURE UPDATE DATE");
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SIGNATURE_SELECT");
		md.setWebLabelName("DEF SIGNATURE SELECT");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SIGNATURE_DELETE");
		md.setWebLabelName("DEF SIGNATURE DELETE");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

	}

}